package com.zjw.mapper;

import com.zjw.entity.po.MeetingPub;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface MeetingPubMapper {
    int deleteByPrimaryKey(String id);

    int insert(MeetingPub record);

    int insertSelective(MeetingPub record);

    MeetingPub selectByPrimaryKey(String id);

    int updateByPrimaryKeySelective(MeetingPub record);

    int updateByPrimaryKey(MeetingPub record);


    //根据会议召开日期 查询当天存在的会议数量
    @Select(" select max(pcode) from meeting_pub where `status`=1 and LEFT(pcode,8)=#{ptime}")
    String selectMaxPcodeByPtime(String ptime);

    //我发表的会议
    List<MeetingPub> selectMeetingPubsByUid(int uid);

}